";
// PHOTOS :::::::::::::::::::::::::::::::
if ($disptype == "photos")
{
// $result=mysql_query("select * from contributions
// where conid=$id");
// $damipics=0;
// $damipics = mysql_num_rows($result);
$result=mysql_query("select COUNT(*), conwpt, description from contributions
left join waypoints on contributions.conwpt=waypoints.waypoint
where contributions.conid=$id
group by conwpt ORDER by description");
$dami = mysql_num_rows($result);
$prevwpt="";
$picctr=0;
echo "There are $damipics photos of $dami destinations on file. ";
if ($signature<>" " and $damipics>0)
echo " [display gallery]";
echo "
";
echo "";
for ($i = 1; $i <= $dami; $i++)
{
$row = mysql_fetch_array($result);
echo " | $row[description] | ";
$presult=mysql_query("select * from contributions
where conid=$id and conwpt=\"$row[conwpt]\"");
$damipics = mysql_num_rows($presult);
echo "";
for ($ii = 1; $ii <= $damipics; $ii++)
{
$prow = mysql_fetch_array($presult);
// $picnumdisp = "P" . substr($prow[confilename],strlen($prow[confilename])-6,2);
$singleshotpath = "singleshots/" . $row[conwpt] . ".jpg";
if (file_exists($singleshotpath))
echo "$prow[confilename] \n";
else
echo "$prow[confilename] \n";
};
echo " | ";
echo " \n";
};
echo " ";
};
// NARRATIVES :::::::::::::::::::::::::::::::::::::
if ($disptype == "narratives")
{
echo "";
$result=mysql_query("select * from narratives
left join waypoints using (waypoint)
where narconid=$id
ORDER by description, nartarget");
$dami = mysql_num_rows($result);
$prevwpt="";
$narctr=0;
$picseq=0;
for ($i = 1; $i <= $dami; $i++)
{
$row = mysql_fetch_array($result);
if ($row[description] <> $prevwpt)
{
echo "| $row[description] | ";
$prevwpt=$row[description];
$narctr=0;
$picseq=0;
};
if (strlen($row[nartarget])==0)
{
echo "Main \n";
}
else
{
// $picseq++;
// $nartypedisp= "P" . $picseq;
echo "$row[nartarget] \n";
// echo "$nartypedisp \n";
};
};
echo " | ";
};
// GPS FILES :::::::::::::::::::::::::::::::::::::::::::;
if ($disptype == "gpsufiles")
{
$result=mysql_query("select * from gpsufiles
left join waypoints on gpsufiles.gpsuwpt=waypoints.waypoint
where gpsuconid=$id
group by gpsuwpt ORDER by gpsuwpt");
$dami = mysql_num_rows($result);
for ($i = 1; $i <= $dami; $i++)
{
$row = mysql_fetch_array($result);
if (strlen($row[gpsuwpt]) == 0)
{
echo "
Wide Area Trackfiles";
}
else
{
echo "
$row[description]\n";
};
$presult=mysql_query("select gpsufilename,gpsudescription from gpsufiles
where gpsuconid=$id and gpsuwpt=\"$row[gpsuwpt]\"");
$damifiles = mysql_num_rows($presult);
for ($ii = 1; $ii <= $damifiles; $ii++)
{
$prow = mysql_fetch_array($presult);
echo "$prow[gpsudescription]\n";
};
};
};
if ($disptype == "waypoints")
{
// look for waypoints on the waypoints.ph database
$result=mysql_query("select waypoint, description, isdetailed from waypoints
where conid=$id
ORDER by description");
$dami = mysql_num_rows($result);
$thirdway=($dami/3);
$echoctr=0;
if ($dami>0)
echo "Waypoints used by this website: ($dami) ** - featured waypoint ";
for ($i = 1; $i <= $dami; $i++)
{
$row = mysql_fetch_array($result);
$detailmark = "";
if ($row[isdetailed]=="Y") $detailmark = "**";
echo "$row[description] $detailmark
\n";
$echoctr++;
if ($echoctr>$thirdway)
{
echo " | ";
$echoctr=0;
};
};
if ($dami>0) echo " |
";
// look for waypoints in the bodega:
$result=mysql_query("select * from bodega
where conid=$id
ORDER by description");
$dami = mysql_num_rows($result);
$thirdway=($dami/3);
$echoctr=0;
if ($dami>0) echo "Waypoints in the Repository: ($dami) ";
for ($i = 1; $i <= $dami; $i++)
{
$row = mysql_fetch_array($result);
echo "$row[description]
\n";
$echoctr++;
if ($echoctr>$thirdway)
{
echo " | ";
$echoctr=0;
};
};
if ($dami>0) echo " |
";
};
if ($disptype == "segments")
{
$result=mysql_query("select * from tracksegments
where conid=$id order by startwpt");
$dami = mysql_num_rows($result);
if ($dami>0) echo "";
for ($i = 1; $i <= $dami; $i++)
{
$row = mysql_fetch_array($result);
$sresult=mysql_query("select * from waypoints
where waypoint = \"$row[startwpt]\"");
$srow = mysql_fetch_array($sresult);
$eresult=mysql_query("select * from waypoints
where waypoint = \"$row[endwpt]\"");
$erow = mysql_fetch_array($eresult);
if (strlen($srow[description])>0 and strlen($erow[description])>0)
echo "| $srow[description] | --> | $erow[description] | \n";
else
echo " | $row[remarks] | | | \n";
};
if ($dami>0) echo " ";
};
echo " |
";
echo " |